
/*
* CategoryDAL
*/
using System;
using System.Collections;
using System.Data;
using System.Data.Common;
using System.Collections.Generic;

using WHC.Pager.Entity;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Carmall.Entity;
using Carmall.IDAL;

namespace Carmall.DAL
{
	/// <summary>
	/// Category DAL 的摘要说明。
	/// </summary>
	public class Category : BaseDAL<CategoryInfo>, ICategory
	{
		#region 对象实例及构造函数

		public static Category Instance
		{
			get
			{
				return new Category();
			}
		}
		public Category() : base("category","CategoryID")
		{
		}

		#endregion

		/// <summary>
		/// 将DataReader的属性值转化为实体类的属性值，返回实体类
		/// </summary>
		/// <param name="dr">有效的DataReader对象</param>
		/// <returns>实体类对象</returns>
		protected override CategoryInfo DataReaderToEntity(IDataReader dataReader)
		{
			CategoryInfo categoryInfo = new CategoryInfo();
			SmartDataReader reader = new SmartDataReader(dataReader);
			
			
			categoryInfo.CategoryID = reader.GetInt32("CategoryID");
			categoryInfo.CategoryName = reader.GetString("CategoryName");
			categoryInfo.ParentID = reader.GetInt32("ParentID");
			categoryInfo.Category = reader.GetString("Category");
			categoryInfo.Notes = reader.GetString("Notes");

			
			return categoryInfo;
		}

		/// <summary>
		/// 将实体对象的属性值转化为Hashtable对应的键值
		/// </summary>
		/// <param name="obj">有效的实体对象</param>
		/// <returns>包含键值映射的Hashtable</returns>
		protected override Hashtable GetHashByEntity(CategoryInfo obj)
		{
			CategoryInfo info = obj as CategoryInfo;
			Hashtable hash = new Hashtable(); 
			
			
			hash.Add("CategoryID", TypeHelper.SafeInt(info.CategoryID));
			hash.Add("CategoryName", TypeHelper.SafeString(info.CategoryName));
			hash.Add("ParentID", TypeHelper.SafeInt(info.ParentID));
			hash.Add("Category", TypeHelper.SafeString(info.Category));
			hash.Add("Notes", TypeHelper.SafeString(info.Notes));

			
			return hash;
		}
	}
}
